/*
 Navicat Premium Data Transfer

 Source Server         : tduck
 Source Server Type    : MySQL
 Source Server Version : 80034 (8.0.34-0ubuntu0.22.04.1)
 Source Schema         : tduck-report

 Target Server Type    : MySQL
 Target Server Version : 80034 (8.0.34-0ubuntu0.22.04.1)
 File Encoding         : 65001

 Date: 21/01/2024 12:41:11
*/

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for rp_dashboard_page
-- ----------------------------
DROP TABLE IF EXISTS `rp_dashboard_page`;
CREATE TABLE `rp_dashboard_page`
(
    `id`              bigint                                                       NOT NULL AUTO_INCREMENT,
    `user_id`         bigint                                                       NOT NULL COMMENT '用户Id',
    `share_key`       varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '唯一key',
    `name`            varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '项目名',
    `publish_status`  tinyint(1) DEFAULT NULL COMMENT '状态',
    `access_password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '访问密码',
    `component_list`  longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '组件列表',
    `page_config`     text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '仪表盘配置',
    `update_time`     datetime                                                      DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `create_time`     datetime                                                      DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY               `user_id` (`user_id`) USING BTREE,
    KEY               `share_key` (`share_key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='报表 仪表盘';

-- ----------------------------
-- Records of rp_dashboard_page
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for rp_data_set
-- ----------------------------
DROP TABLE IF EXISTS `rp_data_set`;
CREATE TABLE `rp_data_set`
(
    `id`             bigint                                                        NOT NULL AUTO_INCREMENT,
    `set_type`       tinyint(1) NOT NULL COMMENT '数据集类型',
    `set_name`       varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  DEFAULT NULL COMMENT '数据集名称',
    `set_desc`       varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  DEFAULT NULL COMMENT '数据集描述',
    `data_source_id` bigint                                                        NOT NULL COMMENT '数据源Id',
    `source_type`    varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '创建来源',
    `source_id`      varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  DEFAULT NULL COMMENT '来源Id',
    `user_id`        bigint                                                         DEFAULT NULL COMMENT '用户Id',
    `dyn_sentence`   varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '动态查询sql或者接口中的请求体',
    `case_result`    text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '结果案例',
    `create_time`    datetime                                                       DEFAULT NULL COMMENT '创建时间',
    `update_time`    datetime                                                       DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='数据集管理';

-- ----------------------------
-- Records of rp_data_set
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for rp_data_source
-- ----------------------------
DROP TABLE IF EXISTS `rp_data_source`;
CREATE TABLE `rp_data_source`
(
    `id`            bigint NOT NULL AUTO_INCREMENT,
    `source_name`   varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  DEFAULT NULL COMMENT '数据源名称',
    `source_desc`   varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  DEFAULT NULL COMMENT '数据源描述',
    `source_type`   tinyint(1) DEFAULT NULL COMMENT '数据源类型单',
    `source_config` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '数据库链接配置',
    `create_by`     varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  DEFAULT NULL COMMENT '创建人',
    `create_time`   datetime                                                       DEFAULT NULL COMMENT '创建时间',
    `update_by`     varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  DEFAULT NULL COMMENT '更新人',
    `update_time`   datetime                                                       DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='报表数据源管理';

-- ----------------------------
-- Records of rp_data_source
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for rp_poster
-- ----------------------------
DROP TABLE IF EXISTS `rp_poster`;
CREATE TABLE `rp_poster`
(
    `id`                 bigint                                                       NOT NULL AUTO_INCREMENT,
    `user_id`            bigint                                                       NOT NULL COMMENT '用户Id',
    `poster_key`         varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '唯一key',
    `name`               varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '项目名',
    `poster_widget_list` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '组件列表',
    `poster_config`      text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '仪表盘配置',
    `update_time`        datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `create_time`        datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY                  `poster_key` (`poster_key`) USING BTREE,
    KEY                  `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='报表 仪表盘';

-- ----------------------------
-- Records of rp_poster
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for rp_poster_form_link
-- ----------------------------
DROP TABLE IF EXISTS `rp_poster_form_link`;
CREATE TABLE `rp_poster_form_link`
(
    `id`          bigint                                                       NOT NULL AUTO_INCREMENT,
    `user_id`     bigint                                                       NOT NULL COMMENT '用户Id',
    `link_key`    varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '关联key',
    `poster_key`  varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '唯一key',
    `form_key`    varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '表单key',
    `desc_text`   text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '描述文本',
    `name`        varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '项目名',
    `fields`      text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '字段映射关系',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `poster_key` (`poster_key`,`form_key`) USING BTREE,
    KEY           `link_key` (`link_key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='海报设计器表单关联';

-- ----------------------------
-- Records of rp_poster_form_link
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for rp_poster_template
-- ----------------------------
DROP TABLE IF EXISTS `rp_poster_template`;
CREATE TABLE `rp_poster_template`
(
    `id`                     bigint                                                        NOT NULL AUTO_INCREMENT,
    `user_id`                bigint   DEFAULT NULL COMMENT '用户Id 为空表示是公共模板',
    `template_image`         varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '模板图片',
    `poster_key`             varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  NOT NULL COMMENT '唯一key',
    `name`                   varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci  NOT NULL COMMENT '项目名',
    `poster_template_config` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '海报配置',
    `update_time`            datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `create_time`            datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY                      `poster_key` (`poster_key`) USING BTREE,
    KEY                      `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='海报模板表';

-- ----------------------------
-- Records of rp_poster_template
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for rp_screen
-- ----------------------------
DROP TABLE IF EXISTS `rp_screen`;
CREATE TABLE `rp_screen`
(
    `id`          bigint                                                       NOT NULL AUTO_INCREMENT,
    `group_id`    bigint                                                       NOT NULL COMMENT '分组',
    `user_id`     bigint                                                       NOT NULL COMMENT '用户Id',
    `share_key`   varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '唯一key',
    `name`        varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '项目名',
    `status`      tinyint(1) DEFAULT NULL COMMENT '状态',
    `password`    varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '访问密码',
    `thumbnail`   varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '缩略图',
    `coms`        longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '组件列表',
    `config`      text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '大屏配置',
    `update_time` datetime                                                      DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `create_time` datetime                                                      DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY           `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='用户数据大屏';

-- ----------------------------
-- Records of rp_screen
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for rp_screen_group
-- ----------------------------
DROP TABLE IF EXISTS `rp_screen_group`;
CREATE TABLE `rp_screen_group`
(
    `id`          bigint                                                       NOT NULL AUTO_INCREMENT,
    `name`        varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '项目名',
    `user_id`     bigint   DEFAULT NULL COMMENT '用户Id',
    `sort`        int(10) unsigned zerofill NOT NULL DEFAULT '0000000000' COMMENT '排序',
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='数据大屏分组';

-- ----------------------------
-- Records of rp_screen_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_announcement
-- ----------------------------
DROP TABLE IF EXISTS `sys_announcement`;
CREATE TABLE `sys_announcement`
(
    `id`           bigint                                                        NOT NULL AUTO_INCREMENT,
    `title`        varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
    `msg_content`  text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
    `start_time`   datetime                                                      DEFAULT NULL COMMENT '开始时间',
    `end_time`     datetime                                                      DEFAULT NULL COMMENT '结束时间',
    `sender`       varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发布人',
    `priority`     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '优先级（L低，M中，H高）',
    `msg_category` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '2' COMMENT '消息类型1:通知公告2:系统消息',
    `msg_type`     varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '通告对象类型（USER:指定用户，ALL:全体用户）',
    `send_status`  varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '发布状态（0未发布，1已发布，2已撤销）',
    `send_time`    datetime                                                      DEFAULT NULL COMMENT '发布时间',
    `cancel_time`  datetime                                                      DEFAULT NULL COMMENT '撤销时间',
    `del_flag`     varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '删除状态（0，正常，1已删除）',
    `bus_type`     varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '业务类型(email:邮件 bpm:流程)',
    `bus_id`       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '业务id',
    `open_type`    varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '打开方式(组件：component 路由：url)',
    `open_page`    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组件/路由 地址',
    `user_ids`     text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '指定用户',
    `msg_abstract` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '摘要',
    `create_by`    varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '创建人',
    `create_time`  datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_by`    varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '更新人',
    `update_time`  datetime                                                      DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统通告表';

-- ----------------------------
-- Records of sys_announcement
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_announcement_send
-- ----------------------------
DROP TABLE IF EXISTS `sys_announcement_send`;
CREATE TABLE `sys_announcement_send`
(
    `id`          bigint NOT NULL AUTO_INCREMENT,
    `annt_id`     varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '通告ID',
    `user_id`     varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户id',
    `read_flag`   varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '阅读状态（0未读，1已读）',
    `read_time`   datetime                                                     DEFAULT NULL COMMENT '阅读时间',
    `create_by`   varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
    `create_time` datetime                                                     DEFAULT NULL COMMENT '创建时间',
    `update_by`   varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
    `update_time` datetime                                                     DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户通告阅读标记表';

-- ----------------------------
-- Records of sys_announcement_send
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`
(
    `id`           bigint NOT NULL AUTO_INCREMENT COMMENT '参数主键',
    `config_name`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '参数名称',
    `config_key`   varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '参数键名',
    `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '参数键值',
    `config_type`  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
    `create_by`    varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '创建者',
    `create_time`  datetime                                                      DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by`    varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '更新者',
    `update_time`  datetime                                                      DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remark`       varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='参数配置表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`,
                          `update_by`, `update_time`, `remark`)
VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2021-07-02 14:22:32', '', NULL,
        '初始化密码 123456');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`,
                          `update_by`, `update_time`, `remark`)
VALUES (9, '开启注册账号', 'sys.account.register', 'Y', 'Y', 'admin', '2022-03-20 13:12:03', 'admin',
        '2022-06-21 19:01:03', '是否开启注册注册账号 Y（是）N（否）');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`,
                          `update_by`, `update_time`, `remark`)
VALUES (10, '注册账号默认角色', 'sys.account.register.roleId', '15', 'Y', 'admin', '2022-03-20 13:35:12', 'admin',
        '2022-03-29 10:53:15', '注册账号默认角色Id 角色管理角色编号字段');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`,
                          `update_by`, `update_time`, `remark`)
VALUES (11, '注册账号默认部门', 'sys.account.register.deptId', '15', 'Y', 'admin', '2022-07-17 22:38:08', 'admin',
        '2022-07-17 22:38:08', '注册账号默认角色Id 角色管理角色编号字段');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`
(
    `id`          bigint NOT NULL AUTO_INCREMENT COMMENT '部门id',
    `parent_id`   bigint                                                       DEFAULT '0' COMMENT '父部门id',
    `ancestors`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '祖级列表',
    `dept_name`   varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '部门名称',
    `order_num`   int                                                          DEFAULT '0' COMMENT '显示顺序',
    `leader`      varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '负责人',
    `phone`       varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系电话',
    `email`       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
    `status`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    `del_flag`    char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    `create_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
    `create_time` datetime                                                     DEFAULT NULL COMMENT '创建时间',
    `update_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
    `update_time` datetime                                                     DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (100, 0, '0', '填鸭科技', 0, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2021-07-02 14:22:31',
        'admin', '2021-08-15 22:56:03');
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (101, 100, '0,100', '深圳总公司', 1, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', NULL);
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (102, 100, '0,100', '长沙分公司', 2, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', '2021-07-14 17:31:38');
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (103, 101, '0,100,101', '研发部门', 1, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', NULL);
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (104, 101, '0,100,101', '市场部门', 2, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', NULL);
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (105, 101, '0,100,101', '测试部门', 3, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', NULL);
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (106, 101, '0,100,101', '财务部门', 4, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', NULL);
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (107, 101, '0,100,101', '运维部门', 5, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', NULL);
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (108, 102, '0,100,102', '市场部门', 1, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', NULL);
INSERT INTO `sys_dept` (`id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`,
                        `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`)
VALUES (109, 102, '0,100,102', '财务部门', 2, 'tduck', '15888888888', 'ry@qq.com', '0', '0', 'admin',
        '2021-07-02 14:22:31', '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_post`;
CREATE TABLE `sys_dept_post`
(
    `id`             bigint                                                 NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `dept_id`        bigint                                                 NOT NULL COMMENT '部门Id',
    `post_id`        bigint                                                 NOT NULL COMMENT '岗位Id',
    `post_show_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '部门岗位显示名称',
    `update_time`    datetime                                               NOT NULL COMMENT '修改时间',
    `create_time`    datetime                                               NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `dept_id` (`dept_id`,`post_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='部门岗位关系表';

-- ----------------------------
-- Records of sys_dept_post
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data`
(
    `id`          bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
    `dict_sort`   int                                                           DEFAULT '0' COMMENT '字典排序',
    `dict_label`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典标签',
    `dict_value`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典键值',
    `dict_type`   varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典类型',
    `css_class`   varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
    `list_class`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '表格回显样式',
    `is_default`  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
    `status`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `create_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '创建者',
    `create_time` datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '更新者',
    `update_time` datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `remark`      varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '性别男');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '性别女');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '性别未知');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '显示菜单');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '隐藏菜单');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '正常状态');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '停用状态');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '正常状态');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '停用状态');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '默认分组');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '系统分组');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '系统默认是');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '系统默认否');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '通知');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '公告');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '正常状态');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '关闭状态');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '新增操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '修改操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '删除操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '授权操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '导出操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '导入操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '强退操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '生成操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '清空操作');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (27, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '正常状态');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (28, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2021-07-02 14:22:32', '', NULL,
        '停用状态');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (32, 0, '查看', 'detail', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin', '2021-08-06 23:21:49',
        'admin', '2021-08-07 21:36:26', NULL);
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (33, 0, '新增', 'add', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin', '2021-08-06 23:23:12', '',
        '2021-08-06 23:23:12', NULL);
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (34, 0, '导入', 'import', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin', '2021-08-06 23:23:31', '',
        '2021-08-06 23:23:31', NULL);
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (35, 0, '导出', 'export', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin', '2021-08-06 23:23:46', '',
        '2021-08-06 23:23:46', NULL);
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (36, 0, '结构查询', 'query', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin', '2021-08-06 23:24:01',
        '', '2021-08-06 23:24:01', NULL);
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (37, 0, '批量操作', 'batchAction', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin',
        '2021-08-06 23:24:22', '', '2021-08-06 23:24:22', NULL);
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (38, 0, '自定义列', 'customColumn', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin',
        '2021-08-06 23:24:33', '', '2021-08-06 23:24:33', NULL);
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (40, 0, '编辑', 'update', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin', '2021-08-06 23:24:59',
        'admin', '2021-08-07 21:36:35', '');
INSERT INTO `sys_dict_data` (`id`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`,
                             `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (41, 0, '删除', 'delete', 'form_perms_btn_type', NULL, 'default', 'N', '0', 'admin', '2021-08-06 23:25:12', '',
        '2021-08-06 23:25:12', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type`
(
    `id`          bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
    `dict_name`   varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典名称',
    `dict_type`   varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典类型',
    `status`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `create_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '创建者',
    `create_time` datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '更新者',
    `update_time` datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `remark`      varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `dict_type` (`dict_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '用户性别列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '菜单状态列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '系统开关列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '任务状态列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '任务分组列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '系统是否列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '通知类型列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '通知状态列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '操作类型列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2021-07-02 14:22:32', '', NULL, '登录状态列表');
INSERT INTO `sys_dict_type` (`id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`,
                             `update_time`, `remark`)
VALUES (28, '表单权限按钮类型', 'form_perms_btn_type', '0', 'admin', '2021-08-06 23:15:30', '', '2021-08-06 23:15:30',
        '表单权限组按钮列表');
COMMIT;

-- ----------------------------
-- Table structure for sys_env_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_env_config`;
CREATE TABLE `sys_env_config`
(
    `id`          bigint                                                        NOT NULL AUTO_INCREMENT COMMENT '参数主键',
    `env_key`     varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '配置key',
    `env_value`   json                                                          NOT NULL COMMENT '参数键值',
    `update_time` datetime                                                               DEFAULT NULL COMMENT '更新时间',
    `create_time` datetime                                                               DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统环境配置表';

-- ----------------------------
-- Records of sys_env_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_env_config` (`id`, `env_key`, `env_value`, `update_time`, `create_time`)
VALUES (9, 'systemInfoConfig', '{
  \"logo\": \"\", \"name\": \"填鸭表单\", \"logoImg\": \"https://oss.tduckcloud.com/tduckpro/a7abb206adf14305a1994f0da6ecb79c.png\", \"copyright\": \"<p>Copyright © 2018-2022 tduckcloud.com All Rights Reserved.</p>\", \"webBaseUrl\": \"https://pro.tduckcloud.com/\"}',
        NULL, '2022-07-17 22:38:46');
INSERT INTO `sys_env_config` (`id`, `env_key`, `env_value`, `update_time`, `create_time`)
VALUES (12, 'emailEnvConfig', '{}', '2021-12-28 16:47:49', '2022-01-10 11:33:49');
INSERT INTO `sys_env_config` (`id`, `env_key`, `env_value`, `update_time`, `create_time`)
VALUES (13, 'smsEnvConfig', '{}', '2021-12-29 11:09:34', '2022-01-10 11:33:49');
INSERT INTO `sys_env_config` (`id`, `env_key`, `env_value`, `update_time`, `create_time`)
VALUES (14, 'fileEnvConfig', '{}', '2021-12-30 11:52:46', '2022-01-10 11:33:49');
INSERT INTO `sys_env_config` (`id`, `env_key`, `env_value`, `update_time`, `create_time`)
VALUES (15, 'wxMpEnvConfig', '{}', '2021-12-30 11:54:53', '2022-01-10 11:33:49');
INSERT INTO `sys_env_config` (`id`, `env_key`, `env_value`, `update_time`, `create_time`)
VALUES (16, 'ocrEnvConfig', '{}', '2022-01-03 17:04:37', '2022-01-10 11:33:49');
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job`
(
    `id`              bigint                                                        NOT NULL AUTO_INCREMENT COMMENT '任务ID',
    `job_name`        varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL DEFAULT '' COMMENT '任务名称',
    `job_group`       varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
    `invoke_target`   varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串',
    `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT '' COMMENT 'cron执行表达式',
    `misfire_policy`  varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
    `concurrent`      tinyint(1) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
    `status`          tinyint(1) DEFAULT '0' COMMENT '状态（0正常 1暂停）',
    `start_time`      datetime                                                               DEFAULT NULL COMMENT '开始时间\r\n',
    `end_time`        datetime                                                               DEFAULT NULL COMMENT '开始时间\r\n',
    `create_by`       varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT '' COMMENT '创建者',
    `create_time`     datetime                                                               DEFAULT NULL COMMENT '创建时间',
    `update_by`       varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT '' COMMENT '更新者',
    `update_time`     datetime                                                               DEFAULT NULL COMMENT '更新时间',
    `remark`          varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT '' COMMENT '备注信息',
    PRIMARY KEY (`id`, `job_name`, `job_group`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务调度表';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` (`id`, `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`,
                       `concurrent`, `status`, `start_time`, `end_time`, `create_by`, `create_time`, `update_by`,
                       `update_time`, `remark`)
VALUES (105, '清除任务日志', 'SYSTEM', 'cleanJobLogTask.cleanAll()', '0 0 0 25 * ?', '1', 1, 0, NULL, NULL, 'admin',
        '2023-06-04 14:19:13', 'admin', '2023-06-04 16:11:32', '');
COMMIT;

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE `sys_job_log`
(
    `id`             bigint                                                        NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
    `job_name`       varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '任务名称',
    `job_group`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '任务组名',
    `invoke_target`  varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串',
    `job_message`    varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '日志信息',
    `status`         tinyint(1) DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
    `exception_info` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '异常信息',
    `start_time`     datetime                                                       DEFAULT NULL COMMENT '开始时间',
    `stop_time`      datetime                                                       DEFAULT NULL COMMENT '结束时间',
    `create_time`    datetime                                                       DEFAULT NULL COMMENT '创建时间',
    `update_time`    datetime                                                       DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务调度日志表';

-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_job_log` (`id`, `job_name`, `job_group`, `invoke_target`, `job_message`, `status`, `exception_info`,
                           `start_time`, `stop_time`, `create_time`, `update_time`)
VALUES (199, '清除任务日志', 'SYSTEM', 'cleanJobLogTask.cleanAll()', '清除任务日志 总共耗时：0毫秒', 0, '',
        '2023-06-04 14:47:29', '2023-06-04 14:47:29', '2023-06-04 14:47:29', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`
(
    `id`          bigint                                                       NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
    `menu_name`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
    `parent_id`   bigint                                                        DEFAULT '0' COMMENT '父菜单ID',
    `order_num`   int                                                           DEFAULT '0' COMMENT '显示顺序',
    `path`        varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '路由地址',
    `component`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组件路径',
    `is_frame`    int                                                           DEFAULT '1' COMMENT '是否为外链（0是 1否）',
    `is_cache`    int                                                           DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
    `menu_type`   char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    `visible`     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
    `status`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
    `perms`       varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限标识',
    `icon`        varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '#' COMMENT '菜单图标',
    `create_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '创建者',
    `create_time` datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '更新者',
    `update_time` datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `remark`      varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1147 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1, '系统管理', 0, 5, 'system', NULL, 1, 0, 'M', '0', '0', '', 'icon-xitongguanli-caidanguanli iconfont',
        'admin', '2021-07-02 14:22:31', 'admin', '2022-01-08 13:58:31', '系统管理目录');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (3, '系统工具', 0, 6, 'tool', NULL, 1, 0, 'M', '0', '0', '', 'icon-jurassic_toolkit iconfont', 'admin',
        '2021-07-02 14:22:31', 'admin', '2022-01-08 13:59:10', '系统工具目录');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', 1, 0, 'C', '0', '0', 'system:user:list',
        'icon-yonghuguanli iconfont', 'admin', '2021-07-02 14:22:31', 'admin', '2021-11-12 17:51:07', '用户管理菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', 1, 0, 'C', '0', '0', 'system:role:list',
        'icon-jiaoseguanli iconfont', 'admin', '2021-07-02 14:22:31', 'admin', '2021-11-12 17:54:46', '角色管理菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', 1, 0, 'C', '0', '0', 'system:menu:list',
        'icon-caidanguanli iconfont', 'admin', '2021-07-02 14:22:31', 'admin', '2021-11-12 17:54:54', '菜单管理菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', 1, 0, 'C', '0', '0', 'system:dept:list',
        'icon-bumenguanli iconfont', 'admin', '2021-07-02 14:22:31', 'admin', '2021-11-12 17:55:01', '部门管理菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', 1, 0, 'C', '0', '0', 'system:post:list',
        'icon-gangweiguanli iconfont', 'admin', '2021-07-02 14:22:31', 'admin', '2021-11-12 17:55:10', '岗位管理菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', 1, 0, 'C', '0', '0', 'system:dict:list',
        'icon-xitongzidian iconfont', 'admin', '2021-07-02 14:22:31', 'admin', '2021-11-12 18:05:46', '字典管理菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', 1, 0, 'C', '0', '0', 'system:config:list',
        'icon-canshu iconfont', 'admin', '2021-07-02 14:22:31', 'admin', '2021-11-12 17:55:34', '参数设置菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (107, '通知公告', 1, 8, 'notice', 'system/announcement/index', 1, 0, 'C', '0', '0', 'system:notice:list',
        'icon-gonggao iconfont', 'admin', '2021-07-02 14:22:32', 'admin', '2021-12-21 11:01:40', '通知公告菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (115, '代码生成', 3, 2, 'gen', 'tool/gen/index', 1, 0, 'C', '0', '0', 'tool:gen:list', 'icon-zitidaima iconfont',
        'admin', '2021-07-02 14:22:32', 'admin', '2021-11-12 17:56:15', '代码生成菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (500, '操作日志', 1, 9, 'operlog', 'system/operlog/index', 1, 0, 'C', '0', '0', 'monitor:operlog:list',
        'icon-rizhi iconfont', 'admin', '2021-07-02 14:22:32', 'admin', '2021-11-13 13:14:25', '操作日志菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1001, '用户查询', 100, 1, '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1002, '用户新增', 100, 2, '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1003, '用户修改', 100, 3, '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1004, '用户删除', 100, 4, '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1005, '用户导出', 100, 5, '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1006, '用户导入', 100, 6, '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1007, '重置密码', 100, 7, '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1008, '角色查询', 101, 1, '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1009, '角色新增', 101, 2, '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1010, '角色修改', 101, 3, '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1011, '角色删除', 101, 4, '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1012, '角色导出', 101, 5, '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1013, '菜单查询', 102, 1, '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1014, '菜单新增', 102, 2, '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1015, '菜单修改', 102, 3, '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1016, '菜单删除', 102, 4, '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1017, '部门查询', 103, 1, '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1018, '部门新增', 103, 2, '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1019, '部门修改', 103, 3, '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1020, '部门删除', 103, 4, '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1021, '岗位查询', 104, 1, '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1022, '岗位新增', 104, 2, '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1023, '岗位修改', 104, 3, '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1024, '岗位删除', 104, 4, '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1025, '岗位导出', 104, 5, '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1026, '字典查询', 105, 1, '#', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1027, '字典新增', 105, 2, '#', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1028, '字典修改', 105, 3, '#', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1029, '字典删除', 105, 4, '#', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1030, '字典导出', 105, 5, '#', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1031, '参数查询', 106, 1, '#', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1032, '参数新增', 106, 2, '#', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1033, '参数修改', 106, 3, '#', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1034, '参数删除', 106, 4, '#', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1035, '参数导出', 106, 5, '#', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1036, '通知查询', 107, 1, '#', '', 1, 0, 'F', '0', '0', 'sys:announcement:query', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1037, '通知新增', 107, 2, '#', '', 1, 0, 'F', '0', '0', 'sys:announcement:save', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1038, '通知修改', 107, 3, '#', '', 1, 0, 'F', '0', '0', 'sys:announcement:update', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1039, '通知删除', 107, 4, '#', '', 1, 0, 'F', '0', '0', 'sys:announcement:delete', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1040, '操作查询', 500, 1, '#', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1041, '操作删除', 500, 2, '#', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1042, '日志导出', 500, 4, '#', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1055, '生成查询', 115, 1, '#', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1056, '生成修改', 115, 2, '#', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1057, '生成删除', 115, 3, '#', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1058, '导入代码', 115, 2, '#', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1059, '预览代码', 115, 4, '#', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1060, '生成代码', 115, 5, '#', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2021-07-02 14:22:32',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1062, '企业表单', 0, 1, 'project', '', 1, 0, 'M', '0', '0', 'project:form:list', 'icon-biaodan iconfont',
        'admin', '2021-07-20 23:02:44', 'admin', '2022-01-08 13:58:54', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1063, '我的表单', 1062, 1, 'my', 'project/my/index', 1, 0, 'C', '0', '0', 'project:my:list',
        'icon-biaodansheji iconfont', 'admin', '2021-07-20 23:07:36', 'admin', '2021-11-12 17:42:13', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1064, '表单模板', 1062, 2, 'template', 'project/template/index', 1, 0, 'C', '0', '0', 'project:template:list',
        'icon-biaodanmoban iconfont', 'admin', '2021-07-20 23:18:47', 'admin', '2021-11-12 17:42:24', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1065, '回收站', 1062, 3, 'recycle', 'project/recycle/index', 1, 0, 'C', '0', '0', 'project:recycle:list',
        'icon-huishouzhan iconfont', 'admin', '2021-07-20 23:19:34', 'admin', '2021-11-12 17:51:48', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1066, '模板删除', 1064, 1, '', NULL, 1, 0, 'F', '0', '0', 'project:template:delete', '#', 'admin',
        '2021-10-17 22:58:09', '', '2021-10-17 22:58:09', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1067, '主题列表', 1073, 3, 'list', 'project/theme/index', 1, 0, 'C', '0', '0', 'form:theme:page',
        'icon-zhutiliebiao iconfont', 'admin', '2021-10-19 17:22:11', 'admin', '2021-11-12 17:52:28',
        '项目主题外观模板菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1068, '主题查询', 1067, 1, '#', '', 1, 0, 'F', '0', '0', 'form:theme:query', '#', 'admin',
        '2021-10-19 17:22:11', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1069, '主题新增', 1067, 2, '#', '', 1, 0, 'F', '0', '0', 'form:theme:save', '#', 'admin', '2021-10-19 17:22:11',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1070, '主题修改', 1067, 3, '#', '', 1, 0, 'F', '0', '0', 'form:theme:update', '#', 'admin',
        '2021-10-19 17:22:11', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1071, '主题删除', 1067, 4, '#', '', 1, 0, 'F', '0', '0', 'form:theme:delete', '#', 'admin',
        '2021-10-19 17:22:11', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1073, '主题模板', 1062, 3, 'theme', NULL, 1, 0, 'M', '0', '0', NULL, 'icon-zhutimoban iconfont', 'admin',
        '2021-10-20 16:08:24', 'admin', '2021-11-12 17:52:05', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1074, '主题分类', 1073, 1, 'themeCategory', 'project/theme/category', 1, 0, 'C', '0', '0',
        'form:theme:category:page', 'icon-gd iconfont', 'admin', '2021-10-20 16:17:05', 'admin', '2021-11-12 17:53:36',
        '单主题分类菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1075, '分类查询', 1074, 1, '#', '', 1, 0, 'F', '0', '0', 'form:theme:category:query', '#', 'admin',
        '2021-10-20 16:17:05', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1076, '分类新增', 1074, 2, '#', '', 1, 0, 'F', '0', '0', 'form:theme:category:save', '#', 'admin',
        '2021-10-20 16:17:05', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1077, '分类修改', 1074, 3, '#', '', 1, 0, 'F', '0', '0', 'form:theme:category:update', '#', 'admin',
        '2021-10-20 16:17:05', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1078, '分类删除', 1074, 4, '#', '', 1, 0, 'F', '0', '0', 'form:theme:category:delete', '#', 'admin',
        '2021-10-20 16:17:05', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1081, '模板分类', 1062, 2, 'themCategory', 'project/template/category', 1, 0, 'C', '0', '0',
        'form:template:category:page', 'icon-mobanfenlei iconfont', 'admin', '2021-10-31 23:17:56', 'admin',
        '2021-11-12 17:42:34', '项目模板分类菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1082, '查询', 1081, 1, '#', '', 1, 0, 'F', '0', '0', 'form:template:category:query', '#', 'admin',
        '2021-10-31 23:17:56', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1083, '新增', 1081, 2, '#', '', 1, 0, 'F', '0', '0', 'form:template:category:save', '#', 'admin',
        '2021-10-31 23:17:56', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1084, '修改', 1081, 3, '#', '', 1, 0, 'F', '0', '0', 'form:template:category:update', '#', 'admin',
        '2021-10-31 23:17:56', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1085, '删除', 1081, 4, '#', '', 1, 0, 'F', '0', '0', 'form:template:category:delete', '#', 'admin',
        '2021-10-31 23:17:56', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1086, '保存模板', 1064, 1, '', NULL, 1, 0, 'F', '0', '0', 'form:template:save', '#', 'admin',
        '2021-11-01 16:59:43', '', '2021-11-01 16:59:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1087, '官网', 0, 7, 'https://tduckcloud.com', NULL, 0, 1, 'C', '0', '0', '', 'icon-xiaoxirizhi iconfont',
        'admin', '2021-11-12 18:26:25', 'admin', '2022-04-22 21:40:06', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1088, '流程审批', 0, 2, 'workflow', NULL, 1, 0, 'M', '0', '0', '', 'icon-liucheng iconfont', 'admin',
        '2021-10-26 22:16:04', '青', '2022-07-03 16:23:13', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1089, '流程部署', 1088, 2, 'workflowd', 'workflow/definition/index', 1, 0, 'C', '0', '0', 'activiti:process',
        'icon-liuchengbushu iconfont', 'admin', '2021-10-26 22:17:44', 'admin', '2021-12-06 14:05:48', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1091, '待办任务', 1088, 4, 'todo', 'workflow/task/todo/index', 1, 1, 'C', '0', '0', '', 'icon-daiban iconfont',
        'admin', '2021-03-26 10:55:52', 'admin', '2021-11-21 22:07:59', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1092, '已办任务', 1088, 4, 'finished', 'workflow/task/finished/index', 1, 1, 'C', '0', '0', '',
        'icon-yiban iconfont', 'admin', '2021-03-26 10:57:54', 'admin', '2021-11-21 22:08:06', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1093, '我的流程', 1088, 2, 'process', 'workflow/task/process/index', 1, 1, 'C', '0', '0', NULL,
        'icon-gerendaiban iconfont', 'admin', '2021-03-30 09:26:23', 'admin', '2021-11-21 22:07:52', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1094, '发起流程', 1093, 1, '', NULL, 1, 0, 'F', '0', '0', 'workflow:process:start', '#', 'admin',
        '2021-12-06 14:24:33', '', '2021-12-06 14:24:33', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1095, '删除流程', 1093, 1, '', NULL, 1, 0, 'F', '0', '0', 'workflow:process:delete', '#', 'admin',
        '2021-12-06 14:24:59', '', '2021-12-06 14:24:59', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1096, '取消流程', 1093, 1, '', NULL, 1, 0, 'F', '0', '0', 'workflow:process:cancel', '#', 'admin',
        '2021-12-06 14:25:42', '', '2021-12-06 14:25:42', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1097, '通知发布', 107, 4, '#', '', 1, 0, 'F', '0', '0', 'sys:announcement:release', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1098, '通知撤回', 107, 4, '#', '', 1, 0, 'F', '0', '0', 'sys:announcement:revoke', '#', 'admin',
        '2021-07-02 14:22:32', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1099, '我的消息', 1100, 9, 'myMsg', 'message/my', 1, 0, 'C', '0', '0', 'sys:mymessage:list',
        'icon-wodexiaoxi iconfont', 'admin', '2021-12-24 16:16:03', '青', '2022-07-02 17:38:22', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1100, '消息中心', 0, 6, 'msg', NULL, 1, 0, 'M', '0', '0', NULL, 'icon-xiaoxizhongxin iconfont', 'admin',
        '2021-12-27 17:30:12', 'admin', '2022-01-10 14:01:53', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1101, '消息日志', 1100, 4, 'log', 'message/log', 1, 0, 'C', '0', '0', 'sys:msglog:list',
        'icon-xiaoxirizhi iconfont', 'admin', '2021-12-27 18:15:28', 'admin', '2021-12-28 15:02:10', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1102, '通知配置', 1100, 1, 'msgtemplate', 'message/template', 1, 0, 'C', '0', '0', 'sys:msgtemplate:list',
        'icon-xiaoximoban1 iconfont', 'admin', '2021-12-28 10:25:00', '青', '2022-07-02 17:39:27', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1103, '消息模板查询', 1102, 1, '#', '', 1, 0, 'F', '0', '0', 'sys:msgtemplate:query', '#', 'admin',
        '2021-12-28 14:58:37', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1104, '消息模板新增', 1102, 2, '#', '', 1, 0, 'F', '0', '0', 'sys:msgtemplate:save', '#', 'admin',
        '2021-12-28 14:58:37', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1105, '消息模板修改', 1102, 3, '#', '', 1, 0, 'F', '0', '0', 'sys:msgtemplate:update', '#', 'admin',
        '2021-12-28 14:58:37', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1106, '消息模板删除', 1102, 4, '#', '', 1, 0, 'F', '0', '0', 'sys:msgtemplate:delete', '#', 'admin',
        '2021-12-28 14:58:37', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1107, '消息查询', 1101, 1, '#', '', 1, 0, 'F', '0', '0', 'sys:msg:page', '#', 'admin', '2021-12-28 15:00:14',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1108, '消息删除', 1101, 4, '#', '', 1, 0, 'F', '0', '0', 'sys:msg:delete', '#', 'admin', '2021-12-28 15:00:14',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1109, '系统配置', 1, 6, 'evnconfig', 'system/config/envconfig', 1, 0, 'C', '0', '0', 'sys:evnconfig:list',
        'icon-xitongshezhi iconfont', 'admin', '2021-12-28 15:55:10', 'admin', '2021-12-28 15:57:27', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1110, '保存配置', 1109, 1, '', NULL, 1, 0, 'F', '0', '0', 'system:envconfig:save', '#', 'admin',
        '2021-12-28 15:57:08', '', '2021-12-28 15:57:08', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1111, '协作表单', 1062, 2, 'shareform', 'project/share/index', 1, 0, 'C', '0', '0', 'project:my:list',
        'icon-biaodansheji iconfont', 'admin', '2021-07-20 23:07:36', 'admin', '2022-02-17 13:46:21', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1112, '待填表单', 1062, 2, 'todo', 'project/todo/index', 1, 0, 'M', '0', '0', 'form:todo:page',
        'icon-chaosong iconfont', 'admin', '2022-12-26 16:57:02', 'admin', '2022-12-27 14:30:02', '待填写表单菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1130, '敏感词库', 1062, 4, 'sensitiveword', 'project/sensitiveword/index', 1, 0, 'C', '0', '0',
        'sys:sensitiveword:page', 'icon-gd iconfont', 'admin', '2023-06-01 20:22:51', 'test02', '2023-06-14 19:58:23',
        '敏感词库菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1131, '敏感词库查询', 1130, 1, '#', '', 1, 0, 'F', '0', '0', 'sys:sensitiveword:query', '#', 'admin',
        '2023-06-01 20:22:51', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1132, '敏感词库新增', 1130, 2, '#', '', 1, 0, 'F', '0', '0', 'sys:sensitiveword:add', '#', 'admin',
        '2023-06-01 20:22:51', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1133, '敏感词库修改', 1130, 3, '#', '', 1, 0, 'F', '0', '0', 'sys:sensitiveword:update', '#', 'admin',
        '2023-06-01 20:22:51', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1134, '敏感词库删除', 1130, 4, '#', '', 1, 0, 'F', '0', '0', 'sys:sensitiveword:delete', '#', 'admin',
        '2023-06-01 20:22:51', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1135, '定时任务', 3, 2, 'job', 'tool/job/index', 1, 1, 'C', '0', '0', 'system:job:list', 'icon-daiban iconfont',
        'admin', '2023-06-04 13:10:32', 'admin', '2023-06-04 13:30:28', '定时任务菜单');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1136, '任务查询', 1135, 1, '#', '', 0, 1, 'F', '0', '0', 'system:job:query', '#', 'admin',
        '2023-06-04 13:14:19', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1137, '任务新增', 1135, 2, '#', '', 0, 1, 'F', '0', '0', 'system:job:add', '#', 'admin', '2023-06-04 13:14:19',
        '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1138, '任务修改', 1135, 3, '#', '', 0, 1, 'F', '0', '0', 'system:job:update', '#', 'admin',
        '2023-06-04 13:14:19', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1139, '任务删除', 1135, 4, '#', '', 0, 1, 'F', '0', '0', 'system:job:remove', '#', 'admin',
        '2023-06-04 13:14:19', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1140, '状态修改', 1135, 5, '#', '', 0, 1, 'F', '0', '0', 'system:job:changeStatus', '#', 'admin',
        '2023-06-04 13:14:19', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1141, '任务导出', 1135, 6, '#', '', 0, 1, 'F', '0', '0', 'system:job:export', '#', 'admin',
        '2023-06-04 13:14:19', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1142, '测试用例流程', 0, 18, 'https://pro.tduckcloud.com/s/X3j9JjYf', NULL, 0, 0, 'M', '0', '0', '',
        'icon-chaosong iconfont', 'admin', '2023-06-07 20:22:00', 'admin', '2023-06-07 20:24:02', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1143, '表单管控', 1062, 1, 'mangeform/index', 'project/mangeform/index', 1, 1, 'C', '0', '0', 'project:my:list',
        'icon-biaodansheji iconfont', 'admin', '2021-07-20 23:07:36', 'test02', '2023-06-14 20:00:43', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1144, '设置部门岗位', 103, 1, '', NULL, 1, 0, 'F', '0', '0', 'system:deptpost:setting', '#', 'admin',
        '2022-06-06 18:06:14', '', '2022-06-06 18:06:14', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1145, '修改部门岗位', 103, 1, '', NULL, 1, 0, 'F', '0', '0', 'system:deptpost:update', '#', 'admin',
        '2022-06-06 18:06:14', '', '2022-06-06 18:06:14', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`,
                        `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1146, '删除部门岗位', 103, 1, '', NULL, 1, 0, 'F', '0', '0', 'system:deptpost:delete', '#', 'admin',
        '2022-06-06 18:06:14', '', '2022-06-06 18:06:14', '');
COMMIT;

-- ----------------------------
-- Table structure for sys_msg
-- ----------------------------
DROP TABLE IF EXISTS `sys_msg`;
CREATE TABLE `sys_msg`
(
    `id`          bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `title`       varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '消息标题',
    `type`        varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci    DEFAULT NULL COMMENT '发送方式：1短信 2邮件 3微信',
    `receiver`    varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '接收人',
    `msg_params`  varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发送所需参数Json格式',
    `content`     longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '推送内容',
    `send_time`   datetime                                                       DEFAULT NULL COMMENT '推送时间',
    `send_status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci    DEFAULT NULL COMMENT '推送状态 0未推送 1推送成功 2推送失败 -1失败不再发送',
    `send_num`    int                                                            DEFAULT NULL COMMENT '发送次数 超过5次不再发送',
    `result`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '推送失败原因',
    `remark`      varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '备注',
    `create_by`   varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '创建人登录名称',
    `create_time` datetime                                                       DEFAULT NULL COMMENT '创建日期',
    `update_by`   varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '更新人登录名称',
    `update_time` datetime                                                       DEFAULT NULL COMMENT '更新日期',
    PRIMARY KEY (`id`) USING BTREE,
    KEY           `index_type` (`type`) USING BTREE,
    KEY           `index_receiver` (`receiver`) USING BTREE,
    KEY           `index_sendtime` (`send_time`) USING BTREE,
    KEY           `index_status` (`send_status`) USING BTREE,
    KEY           `idx_ss_es_type` (`type`) USING BTREE,
    KEY           `idx_ss_es_receiver` (`receiver`) USING BTREE,
    KEY           `idx_ss_es_send_time` (`send_time`) USING BTREE,
    KEY           `idx_ss_es_send_status` (`send_status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_msg
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_msg_template
-- ----------------------------
DROP TABLE IF EXISTS `sys_msg_template`;
CREATE TABLE `sys_msg_template`
(
    `id`                bigint                                                       NOT NULL AUTO_INCREMENT COMMENT '主键',
    `template_name`     varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板标题',
    `template_code`     varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板CODE',
    `template_type`     varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '模板类型：1短信 2邮件 3微信',
    `template_content`  varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '模板内容',
    `third_template_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '三方模板',
    `create_time`       datetime                                                       DEFAULT NULL COMMENT '创建日期',
    `create_by`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '创建人登录名称',
    `update_time`       datetime                                                       DEFAULT NULL COMMENT '更新日期',
    `update_by`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '更新人登录名称',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uniq_templatecode` (`template_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_msg_template
-- ----------------------------
BEGIN;
INSERT INTO `sys_msg_template` (`id`, `template_name`, `template_code`, `template_type`, `template_content`,
                                `third_template_id`, `create_time`, `create_by`, `update_time`, `update_by`)
VALUES (4, '新表单数据邮件通知', 'EmailNewWriteNotify', '2',
        '<!DOCTYPE html>\r\n<html lang=\"zh\" xmlns:th=\"http://www.thymeleaf.org\">\r\n<head>\r\n    <meta charset=\"UTF-8\"/>\r\n    <title>TDUCK-您的项目收到新的反馈</title>\r\n</head>\r\n<body>\r\n<h4>您的项目<h4>${formName</h4>收到新的反馈</h4>\r\n</body>\r\n</html>\r\n\r\n',
        '111', '2021-12-29 17:41:47', NULL, '2021-12-30 14:08:22', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log`
(
    `id`             bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键',
    `title`          varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT '' COMMENT '模块标题',
    `business_type`  int                                                            DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
    `method`         varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '方法名称',
    `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT '' COMMENT '请求方式',
    `operator_type`  int                                                            DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
    `oper_name`      varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT '' COMMENT '操作人员',
    `dept_name`      varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT '' COMMENT '部门名称',
    `oper_url`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '请求URL',
    `oper_ip`        varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '主机地址',
    `oper_location`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '操作地点',
    `oper_param`     varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '请求参数',
    `json_result`    varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '返回参数',
    `status`         int                                                            DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
    `error_msg`      varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '错误消息',
    `oper_time`      datetime                                                       DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '操作时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=525 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='操作日志记录';

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post`
(
    `id`          bigint                                                       NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
    `post_code`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码',
    `post_name`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称',
    `status`      tinyint(1) NOT NULL COMMENT '状态（0正常 1停用）',
    `leader_post` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否领导岗位',
    `level`       int                                                          NOT NULL COMMENT '岗位层级，数值越小级别越高',
    `create_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '创建者',
    `create_time` datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '更新者',
    `update_time` datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `remark`      varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='岗位信息表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` (`id`, `post_code`, `post_name`, `status`, `leader_post`, `level`, `create_by`, `create_time`,
                        `update_by`, `update_time`, `remark`)
VALUES (1, 'ceo', '董事长', 0, 0, 0, 'admin', '2021-07-02 14:22:31', '', NULL, '');
INSERT INTO `sys_post` (`id`, `post_code`, `post_name`, `status`, `leader_post`, `level`, `create_by`, `create_time`,
                        `update_by`, `update_time`, `remark`)
VALUES (2, 'se', '项目经理', 0, 0, 0, 'admin', '2021-07-02 14:22:31', '', NULL, '');
INSERT INTO `sys_post` (`id`, `post_code`, `post_name`, `status`, `leader_post`, `level`, `create_by`, `create_time`,
                        `update_by`, `update_time`, `remark`)
VALUES (3, 'hr', '人力资源', 0, 0, 0, 'admin', '2021-07-02 14:22:31', '', NULL, '');
INSERT INTO `sys_post` (`id`, `post_code`, `post_name`, `status`, `leader_post`, `level`, `create_by`, `create_time`,
                        `update_by`, `update_time`, `remark`)
VALUES (4, 'user', '普通员工', 0, 0, 0, 'admin', '2021-07-02 14:22:31', '', NULL, '');
INSERT INTO `sys_post` (`id`, `post_code`, `post_name`, `status`, `leader_post`, `level`, `create_by`, `create_time`,
                        `update_by`, `update_time`, `remark`)
VALUES (9, 'devleader', '研发经理', 0, 0, 0, 'admin', '2021-12-10 11:31:14', '', '2021-12-10 11:31:14', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`
(
    `id`                  bigint                                                        NOT NULL AUTO_INCREMENT COMMENT '角色ID',
    `role_name`           varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '角色名称',
    `role_key`            varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色权限字符串',
    `role_sort`           int                                                           NOT NULL COMMENT '显示顺序',
    `data_scope`          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
    `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
    `dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',
    `status`              char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL COMMENT '角色状态（0正常 1停用）',
    `del_flag`            char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    `create_by`           varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '创建者',
    `create_time`         datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_by`           varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '更新者',
    `update_time`         datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `remark`              varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`,
                        `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2021-07-02 14:22:31', '', NULL, '超级管理员');
INSERT INTO `sys_role` (`id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`,
                        `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (2, '普通角色', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2021-07-02 14:22:31', 'admin', '2021-12-31 14:40:44',
        '普通角色');
INSERT INTO `sys_role` (`id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`,
                        `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (13, '测试角色', 'test', 0, '3', 1, 1, '0', '0', 'admin', '2021-07-15 21:41:28', 'admin', '2021-11-04 13:24:27',
        NULL);
INSERT INTO `sys_role` (`id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`,
                        `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`,
                        `update_time`, `remark`)
VALUES (37, '人事角色', 'hr', 1, '1', 1, 1, '0', '0', 'admin', '2021-12-10 13:56:54', '', '2021-12-10 13:56:54', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept`
(
    `id`          bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
    `role_id`     bigint NOT NULL COMMENT '角色ID',
    `dept_id`     bigint NOT NULL COMMENT '部门ID',
    `create_time` datetime                                                     DEFAULT NULL COMMENT '创建时间',
    `update_time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色和部门关联表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`
(
    `id`          bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    `role_id`     bigint NOT NULL COMMENT '角色ID',
    `menu_id`     bigint NOT NULL COMMENT '菜单ID',
    `update_time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
    `create_time` datetime                                                     DEFAULT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1481 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_sensitive_word
-- ----------------------------
DROP TABLE IF EXISTS `sys_sensitive_word`;
CREATE TABLE `sys_sensitive_word`
(
    `id`          bigint                                                        NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `word`        varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '敏感词',
    `type`        tinyint(1) NOT NULL COMMENT '类型',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新者',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='敏感词库表';

-- ----------------------------
-- Records of sys_sensitive_word
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_upgrade_property
-- ----------------------------
DROP TABLE IF EXISTS `sys_upgrade_property`;
CREATE TABLE `sys_upgrade_property`
(
    `id`          bigint                                                       NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `key_name`    varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'key',
    `status`      tinyint(1) DEFAULT NULL,
    `file_blob`   blob COMMENT '文件附件',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新者',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `key_name` (`key_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='系统升级属性表';

-- ----------------------------
-- Records of sys_upgrade_property
-- ----------------------------
BEGIN;
INSERT INTO `sys_upgrade_property` (`id`, `key_name`, `status`, `file_blob`, `create_time`, `update_time`)
VALUES (1, 'FORM_NAME_UPGRADE_PROPERTY', 1, NULL, '2023-07-05 12:02:53', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`
(
    `id`          bigint                                                       NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `dept_id`     bigint                                                        DEFAULT NULL COMMENT '部门ID',
    `user_name`   varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账号',
    `nick_name`   varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户昵称',
    `user_type`   varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT '00' COMMENT '用户类型（00系统用户）',
    `email`       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '用户邮箱',
    `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '手机号码',
    `sex`         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
    `avatar`      varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '头像地址',
    `password`    varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '密码',
    `status`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
    `del_flag`    char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    `login_ip`    varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '最后登录IP',
    `login_date`  datetime                                                      DEFAULT NULL COMMENT '最后登录时间',
    `create_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '创建者',
    `create_time` datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT '' COMMENT '更新者',
    `update_time` datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `remark`      varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`,
                        `password`, `status`, `del_flag`, `login_ip`, `login_date`, `create_by`, `create_time`,
                        `update_by`, `update_time`, `remark`)
VALUES (1, 103, 'admin', '填鸭', '00', 'admin@tduckapp.com', '15666666666', '0',
        'https://oss.tduckcloud.com/02c41763e19749209cb8161f13da144a.png',
        '$2a$10$/8bU6ayfPjuV9Eu8VGCEYuwARKUjUVSzRS95IxITBjd9GHAmEm5/m', '0', '0', '127.0.0.1', '2024-01-21 12:23:21',
        'admin', '2021-07-02 14:22:31', '', '2024-01-21 12:23:21', '管理员');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post`
(
    `id`          bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `user_id`     bigint NOT NULL COMMENT '用户ID',
    `post_id`     bigint NOT NULL COMMENT '岗位ID',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新者',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户与岗位关联表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`
(
    `id`          bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `user_id`     bigint NOT NULL COMMENT '用户ID',
    `role_id`     bigint NOT NULL COMMENT '角色ID',
    `create_time` datetime                                                     DEFAULT NULL COMMENT '创建时间',
    `update_time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
    PRIMARY KEY (`id`, `role_id`, `user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
COMMIT;
CREATE TABLE `rp_form_data_source`
(
    `id`          bigint                                                        NOT NULL AUTO_INCREMENT,
    `source_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据源名称',
    `source_desc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '数据源描述',
    `form_key`    varchar(255)                                                  DEFAULT NULL COMMENT '表单key',
    `fields`      json                                                          DEFAULT NULL COMMENT '字段',
    `user_id`     bigint                                                        NOT NULL COMMENT '用户',
    `create_time` datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_time` datetime                                                      DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='表单数据源';
BEGIN;
COMMIT;
SET
FOREIGN_KEY_CHECKS = 1;
